package com.jzo2o.customer.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jzo2o.customer.model.domain.WorkerCertification;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface CertificationMapper extends BaseMapper<WorkerCertification> {
    //查询最新驳回原因
    @Select("SELECT reject_reason FROM worker_certification_audit WHERE certification_status = 3 ORDER BY create_time DESC LIMIT 1;")
    String getrejectReason();
}
